In the real application,in order to make the PL/SQL function returns the data in multiple rows ,must by returning a REF CURSOR or a data set to complete .REF CURSOR this is limited to selected data from the query ,and the entire collectio …